Flash and PHP Bible

The Flash and PHP Bible has been released! The book can be found on Amazon or wherever fine books are sold in your area.

The Flash and PHP Bible has a forum for quick support.

[Snippet] Backup and Restore MySQL from command line

[Snippet] Backup and Restore MySQL from command line

How to quickly backup a MySQL database using the command line.

Here is how to quickly backup a MySQL database using the command line.

Start by opening Terminal (Mac) or Putty (Win) and follow these commands.

Backing up a database

mysqldump -h hostname -u user --password=pass databasename > filename

Restoring a database

mysql -h hostname -u user --password=pass databasename < filename

Replace the hostname, user, pass, databasename and filename with the values for your own server.

Reposted from mkeefeDESIGN Blog

Print It | Follow Scriptplayground on Twitter (@scriptplay)

Comments: [Snippet] Backup and Restore MySQL from command line

No Comments have been made. Wanna be the first?

Add a comment

Name:
Website:

Comment:

Please note: Offensive comments, flaming and spamming is not permitted on this site and your comment will be deleted immediately.

HTML is not allowed.

Please provide all comments in English so that others can help you. A common helper in this is to use an online translator.

As a security measure your ip will be recorded.

Anti-Robot Check:

Enter the key you see above.

What is this?: This extra test has been added due to the recent explosion of spam.

Scriptplayground Network